Text copied to clipboard!

Title

Text copied to clipboard!

Oracle Application Programmer

Description

Text copied to clipboard!
We are looking for an Oracle Application Programmer to join our dynamic technology team. This role is ideal for someone with a strong background in Oracle development, including PL/SQL, Oracle Forms, and Oracle Reports, and who is passionate about building scalable, high-performance enterprise applications. The Oracle Application Programmer will be responsible for designing, developing, testing, and maintaining Oracle-based applications that support various business functions across the organization. The ideal candidate will have experience working in a structured development environment and be familiar with the software development life cycle (SDLC). You will collaborate closely with business analysts, project managers, and other developers to understand business requirements and translate them into technical solutions. You will also be responsible for troubleshooting and resolving application issues, optimizing performance, and ensuring data integrity and security. In this role, you will work on both new development projects and the enhancement of existing systems. You will be expected to write clean, efficient, and well-documented code, and to participate in code reviews and testing activities. A strong understanding of relational databases, data modeling, and Oracle database architecture is essential. We are looking for someone who is detail-oriented, analytical, and capable of working independently as well as part of a team. Excellent communication skills are a must, as you will be interacting with both technical and non-technical stakeholders. If you are looking for a challenging and rewarding opportunity to grow your career in Oracle application development, we encourage you to apply.

Responsibilities

Text copied to clipboard!
  • Design, develop, and maintain Oracle-based applications
  • Write and optimize PL/SQL code and stored procedures
  • Develop Oracle Forms and Reports as needed
  • Collaborate with business analysts to gather requirements
  • Perform unit testing and support system testing
  • Troubleshoot and resolve application issues
  • Ensure data integrity and application security
  • Participate in code reviews and documentation
  • Support deployment and post-deployment activities
  • Maintain technical documentation for applications

Requirements

Text copied to clipboard!
  • Bachelor’s degree in Computer Science or related field
  • 3+ years of experience in Oracle application development
  • Proficiency in PL/SQL, Oracle Forms, and Oracle Reports
  • Strong understanding of relational databases and data modeling
  • Experience with Oracle 11g/12c or higher
  • Familiarity with SDLC and Agile methodologies
  • Excellent problem-solving and analytical skills
  • Strong communication and teamwork abilities
  • Ability to manage multiple tasks and deadlines
  • Experience with performance tuning and optimization

Potential interview questions

Text copied to clipboard!
  • How many years of experience do you have with Oracle PL/SQL?
  • Have you developed applications using Oracle Forms and Reports?
  • Can you describe a complex Oracle application you’ve built?
  • What is your experience with performance tuning in Oracle?
  • Are you familiar with Agile or other development methodologies?
  • How do you ensure data integrity in your applications?
  • Have you worked in a team environment with business analysts?
  • What tools do you use for version control and deployment?
  • How do you handle application troubleshooting and debugging?
  • Are you comfortable working independently and managing deadlines?